Word | Frequency | Number of right neighbors | Number of left neighbors | Ratio |
---|---|---|---|---|
Бу | 1313 | 57 | 1 | 57.0000 |
Бүген | 829 | 41 | 1 | 41.0000 |
Әлеге | 428 | 28 | 1 | 28.0000 |
Әмма | 317 | 16 | 1 | 16.0000 |
Алар | 390 | 12 | 1 | 12.0000 |
Узган | 216 | 11 | 1 | 11.0000 |
ә | 543 | 22 | 2 | 11.0000 |
Хәзер | 189 | 10 | 1 | 10.0000 |
бергә | 199 | 10 | 1 | 10.0000 |
әмма | 165 | 10 | 1 | 10.0000 |
Быел | 182 | 9 | 1 | 9.0000 |
Соңгы | 139 | 9 | 1 | 9.0000 |
кулга | 74 | 8 | 1 | 8.0000 |
Беренче | 129 | 8 | 1 | 8.0000 |
нигез | 73 | 8 | 1 | 8.0000 |
Миңнеханов | 300 | 16 | 2 | 8.0000 |
тарихы | 83 | 8 | 1 | 8.0000 |
урта | 130 | 15 | 2 | 7.5000 |
2008 | 83 | 7 | 1 | 7.0000 |
сатып | 169 | 14 | 2 | 7.0000 |
Word | Frequency | Number of right neighbors | Number of left neighbors | Ratio |
---|---|---|---|---|
итүче | 122 | 1 | 16 | 0.0625 |
узды | 229 | 1 | 15 | 0.0667 |
алачак | 132 | 1 | 11 | 0.0909 |
килде | 196 | 1 | 10 | 0.1000 |
фикеренчә | 179 | 1 | 10 | 0.1000 |
булды | 630 | 4 | 38 | 0.1053 |
алганда | 194 | 1 | 9 | 0.1111 |
иде | 1203 | 10 | 84 | 0.1190 |
ителәчәк | 103 | 1 | 8 | 0.1250 |
мөселманнары | 64 | 1 | 8 | 0.1250 |
итте | 657 | 3 | 22 | 0.1364 |
эчке | 133 | 1 | 7 | 0.1429 |
районының | 88 | 1 | 7 | 0.1429 |
калды | 67 | 1 | 7 | 0.1429 |
барысы | 104 | 1 | 7 | 0.1429 |
алды | 217 | 2 | 14 | 0.1429 |
сәбәпле | 133 | 1 | 7 | 0.1429 |
яшәгән | 97 | 1 | 7 | 0.1429 |
китте | 90 | 1 | 7 | 0.1429 |
әйтте | 172 | 2 | 13 | 0.1538 |
In this subsection, we compute the ratio of the number of right neighbors and the number of left neighbors. Again, we look for words with extreme ratios:
Data for first table:
select word,w.freq,aa.cnt, bb.cnt,aa.cnt/bb.cnt as r from words w, (select w1_id,count(c.w2_id) as cnt from co_n c where w1_id>100 group by w1_id) aa, (select w2_id,count(c.w1_id) as cnt from co_n c where w2_id>100 group by w2_id) bb where w_id=aa.w1_id and aa.w1_id=bb.w2_id order by r desc limit 20;
Diagram data:
select aa.cnt, bb.cnt from (select w1_id,count(c.w2_id) as cnt from co_n c where w1_id>100 group by w1_id) aa, (select w2_id,count(c.w1_id) as cnt from co_n c where w2_id>100 group by w2_id) bb where aa.w1_id=bb.w2_id;
5.1.7.1 Number of NN co-occurrences vs. Frequency I
5.1.7.2 Number of NN co-occurrences vs. Frequency II